EMT Practice Test

1. Question Content...


Question List

Question1: A consultant created a dashboard using Einstein Analytics for her client, a shipping company. It sources data from very large datasets. Now the client has requested that the consultant add more steps to the dashboard.
To ensure that the dashboard has acceptable performance, what two actions should the consultant take? Choose 2 answers

Question2: When organizing information in an Einstein Analytics dashboard, what does the "Progressive Disclosure' design principle mean'

Question3: What permissions are necessary for someone to edit the XMD?

Question4: The Universal Containers company used Einstein Analytics to create two datasets:
Dataset A: contains a list of activities with an "activitylD" dimension and a "userlD" dimension Dataset B: contains a list of users with a "userlD" dimension The team wants to delete from Dataset A all activities related to users in Dataset B.
How can an Einstein Consultant help them achieve this?

Question5: A consultant built a very useful Einstein Analytics app for the corporate Sales Operations team of a company that has multiple Salesforce Ogrs, Each Org has similar models and would like to review their data the way that the corporate Sales Operations team does. The app has been packaged and needs to be installed on the other production orgs.
What is the recommended practice to install the custom template app?

Question6: A Einstein Analytics consultant is asked to help a company report on their sales activity. The company wants to train some users to create their own dashboards. They also want another team to only be able to use the dashboards.
What must be configured to address these requirements?

Question7: The Universal Containers company uses a Microsoft Azure SQL Data Warehouse to gather information about sales representatives' objectives. They want to use Einstein Analytics to gain insights from this data; therefore, they need to automatically load the warehouse's data into an Einstein Analytics dataset on a daily basis. The data also needs to be transformed and merged with data from the company's org.
Which three Einstein Analytics user interface features can be used to complete these requirements? Choose 3 answers

Question8: A small Business Intelligence team is overwhelmed with multiple requests to create new dashboards. An option is to use layout templates to help with dashboard development.
What are two advantages of using layout templates? Choose 2 answers

Question9: What can you change in a Compare Table formula column?

Question10: Creating an Einstein Discovery story involves:

Question11: Which of the following are requirements for enabling Analytics for Communities?

Question12: An Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle database.
What are two options to load the data from the Oracle database into Einstein Analytics? Choose 2 answers

Question13: A consultant built an Einstein Analytics app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
A set of JSON files will be generated after a template is created from the Sales Operations app. What is the name of the JSON file that manages template metadata and all other template elements'

Question14: What's a good way to see which required questions in the configuration wizard don't have default values?

Question15: Which of the following are included in the template object?

Question16: Why would you use a merge key in a dataset recipe?

Question17: Exhibit:

Universal Containers has a Sales Manager dashboard. They need to build a table as shown in the graphic and calculate the summary as the first line in a compare table.
How can the summary be calculated'

Question18: How do you create a regression timeseries?

Question19: A consultant is asked to configure a user to view a dashboard, within a designated app, without the ability to create and save lenses. After adding the user to the app, which action should the consultant take to implement this requirement?

Question20: Why is it important to prepare the data in a CSV file before you bring it into Analytics?

Question21: The client is trying to create a SAQL step to predict sales in each sales region. They cannot get the query to return any results, but have identified that the error is in the time series statement. They have asked an Einstein Consultant to review the following query and fix any errors.

Which timeseries statement will fix the query'

Question22: What is the test called that helps to identify categories that exhibit a pattern outside the overall average?

Question23: What is another name for the type of insight that examines how one variable explains variation of the outcome variable?

Question24: Results from an Einstein Discovary story are reviewed with a business user. They agree with the findings but noticed that none of the fields used in the story have a correlation value greater than 4%. The client is now concerned that the model may not be good enough to next steps?

Question25: Salesforce Analytics is...

Question26: A consultant built a very useful Einstein Analytics app for Sales Operations and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as an Einstein Analytics template app, but needs to locate specific information to get started.
What is the REST API URL where the consultant can find current template apps?

Question27: Which three parameters are used in a compare table formula field to calculate and display a field as percentage value? Choose 3 answers

Question28: The Event Monitoring Analytics app brings prebuilt insights and analytics to what type of existing data in your org?

Question29: The Einstein Analytics team at a company created a clataset based on the Opportunity__c custom object. The VP of Sales reports seeing the message "No results found" when opening the dataset to explore it. Other users below the VP in the role hierarchy can see rows on the same dataset. Which two problems might be causing this issue?

Question30: Timeout for ETL jobs that have been scheduled but not executed

Question31: Universal Containers reports that any selection in the List widget is not affecting the Pie chart in one of their Einstein Analytics dashboards. The step options associated with the List widget and Pie chart are shown in the graphic.

Which two changes can an Einstein Consultant implement to solve this issue, given that the steps are using the same dataset? Choose 2 answers

Question32: Which Einstein Analytics asset or assets are created when using an App Template to create an app?

Question33: A consultant wants to understand what the important predictors are in the story.
What are two places where this information can be found?
Choose 2 answers

Question34: Maximum concurrent API Analytics calls per org

Question35: Which dataflow transformation does data sync (replication) reference, in an existing dataflow, to determine which Salesforce objects and fields are currently being extracted?

Question36: Mosaic recently hired a new development coordinator, Zoe. First, Danielle grants Zoe the Einstein Analytics Platform license, but Zoe reports that she still can't access Einstein Analytics. What could be the problem?

Question37: What are the steps in the data exploration process?

Question38: A consultant is tasked with creating one query that shows how many opportunities and cases there are per account.
Cases and opportunities are found in two different datasets with a reference to the related Account via the AccoundId.
What options do the consultant have in Analytics Studio to create the query?

Question39: Where can you view the status of a CSV upload in Analytics?

Question40: A company created a dataset called myExternalDataset. It contains a dimension, called UserRegion, that is populated by the standard User object's picklist: Region.
The company has security requirements for this dataset:
1. Only a subset of users should be able to access the dataset.
2. Users who can access the dataset should see only data that belongs to their region.
In which two ways can an Einstein Analytics consultant help them implement these requirements? Choose 2 answers

Question41: In what order does Einstein Discovery present the insights that it uncovers?

Question42: When creating a story in Einstein Discovery, do all potential collinear fields need to be removed before executing the build story'5

Question43: Which two recommended techniques can be used to access tableau CRM data from a remote app or website? Choose 2 answers

Question44: A story has been deployed to the Opportunity object with a prediction field, Predicted Amount.
How can all the Opportunity records be predictions written back to the Predicted Amount field?

Question45: What is a valid permission for a permission set?

Question46: What does the Division is Naval section of the waterfall graph tell you?

Question47: A company asks a Tableau CRM consultant to review the performance of their local data sync.
After removing unused objects and fields from connected
data, what else can the consultant do to improve performance of data sync"*

Question48: The edgemart transformation gives the dataflow access to an existing, registered dataset that can contain Salesforce data, external data, or a combination of both.
Where is an edgemart transformation specified?

Question49: Which widget property allows a consultant to restrict the view to a domain bounded by the values entered'

Question50: What are the 3 basic actions within a query in Analytics? Choose 3:

Question51: Universal Containers has a dashboard for Sales Managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. An Einstein Consultant created a static step to display three values: ClosedDate_month, ClosedDate_quarter, and ClosedDate_year.
What should the consultant do next?

Question52: Which chart type is suitable for rendering five measures in a lens visualization?

Question53: Which three statements are true regarding sharing inheritance? Choose 3 answers

Question54: Which set of statements generates monthly amount on a cumulative basis annually?

Question55: After loading data to Einstein Discovery and creating a story, the client asks the Einstein Consultant to explain the "Unexplained Bar" in the "Why it Happened" chart.
Which explanation is correct?

Question56: What happens if you first disable Analytics, and then you re-enable Analytics later? Select 2

Question57: A consultant wants to optimize data loads by extracting Salesforce objects using independent Einstein Analytics dataflows ahead of time. Which construct should be used to accomplish this?

Question58: The Tableau CRM team at a company creates three recipes.
1) myRecipeOne: this recipe takes 2 hours to run.
2) mvRedpeTwo: this recipe takes 1 hour and 30 minutes to run.
3) myRecipeThree: this recipe takes 1 minute and 30
seconds to run.
If all three recipes run, how many count towards the 24 hour rolling recipe run limit.

Question59: A consultant is working with the client to define goals and metrics for an app that will be built. The consultant decides to base the dashboards on personas and is in the design phase prior to starting the actual build.
Which two design considerations should be determined at this time? Choose 2 answers

Question60: A consultant created an Einstein Analytics dashboard in a sandbox. Now, the dashboard needs to be migrated into production.
To complete the migration, what are the consultant's three options? Choose 3 answers

Question61: A consultant built a very useful Einstein Analytics app for Sales Operations, and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as an Einstein Analytics template app, but needs to locate specific information to get started.

Given the code statement above, which endpoint should it be posted to?

Question62: Which of these standard deviations is for a curve that has values that are the most spread out away from the average?

Question63: Benito has Viewer access to a new Einstein Analytics app. He wants to build and edit a dashboard using the Seed Bank dataset in this new app. What must an admin do for Benito to do this?

Question64: Which chart type is best suited to track progress of sales revenue that is realized versus the target?

Question65: How do you analyze data from a CSV file using Einstein Discovery?

Question66: The Universal Containers Einstein Analytics team built a dashboard with two widgets:
1. List widget associated to the step "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Pie chart widget associated to the step "Step_pie_3" and grouped by the dimension "Type" The team wants to use bindings so any selection in the List widget will filter the Pie chart.
Additional notes:
* The steps use different datasets.
* Users should be able to choose more than one Type (multi-selection).
What is the right syntax for the binding?

Question67: What do you have to assign to users before they can access Analytics?

Question68: An Einstein Analytics team reports that when they start their dataflow it runs successfully with no errors or warnings, but one of the fields does not return values when it is queried.
What can be the origin of this issue?

Question69: A customer displays a lot of data and wants a way to dynamically emphasize certain values on a bar chart in order to properly grab the user's attention.
What can an Einstein Consultant use to accomplish this task?

Question70: What is a keyword in SAQL? And what case must it be in?

Question71: A Salesforce administrator wants to create a new dashboard that uses custom geoJSON to display data; however, the administrator is unable to upload the file via the UI.
What should be done?

Question72: A consultant is asked to create a dashboard for sales to see the forecasted sales per product family. After gathering the requirements, the consultant decides to leverage the timeseries SAQL statement to predict sales.
Which two actions must be performed when writing the SAQL query?
Choose 2 answers

Question73: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
In which two ways can this be accomplished? Choose 2 answers

Question74: In what order does Einstein Discovery present the insights that it uncovers?

Question75: Can you share dashboards with others in your org?

Question76: What do you have to assign to users before they can access Analytics?

Question77: The Universal Containers company uses Einstein Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users for the same department have the same role and need to have access to the same dashboards. Dashboards for different departments use some common datasets with the same row-level security.
How can an Einstein Consultant address this need?

Question78: Universal Containers is evaluating the connection mode for the objects in their local Salesforce connector. They want to only sync updated and new records from the Order object, but they have some formula fields on the object and want to ensure those are updated weekly.
which
Which connection mode is best suited for this purpose?

Question79: What can you do on the Edit Field Attributes page when uploading a CSV file to Analytics?

Question80: A consultant built an Einstein Analytics app for the Sales Operations team. The team wants to share this app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.
In the process of creating the template, which role does the original Einstein Analytics app for the Sales Operation team play?

Question81: A large company has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able to view the attainment data for each rep in their division. Each rep should only be able to see their own commission data.
Which option should be used to enforce this requirement?

Question82: A story created has an AUC of .62.
What two things could be done to possible improve this AUC score?
Choose 2 answers

Question83: A consultant is creating a Churn Prediction model to identify customers who are not likely to renew their contract.
What is the appropriate action to take?

Question84: A company used Einstein Analytics to create two datasets:
1. "Opportunity With Account- dataset, which contains data from the Opportunity standard object augmented by the Account data.
2. "Case with Account" dataset. which contains data from the Case standard object augmented by the Account data.
The company wants to build a lens showing the total number of Opportunities and Cases per Account. How can a consultant help them build this lens'

Question85: Universal Containers reports that any selection in the List widget is not affecting the Pie chart in one of their Einstein Analytics dashboards. The step options associated with the List widget and Pie chart are shown in the graphic.

Given that the steps are using different datasets. which two changes can an Einstein Consultant make to solve this issue' Choose 2 answers

Question86: Using the Setup menu, the Universal Containers company activated data sync (replication) in the Einstein Analytics settings. After running the sync, they notice that the aggregate sum of a field within their dataset is different than what they manually calculated by summing the same data in the Salesforce object from which the dataset was populated.
Which two differences in the newly synced data can explain this? Choose 2 answers

Question87: Default rows in values table

Question88: A company wants to use Einstein Analytics to analyze the trend of their sales pipeline. The company wants to accelerate the sales process. To do so, they need to know the average time an opportunity spends in each stage. This value is not pre-calculated in Salesforce, so a consultant recommends using a dataflow to calculate it.
How can a dataflow be used to calculate the average time an opportunity spends in each stage?

Question89: Exhibit:

A company wants to create a timeline chart to visualize the evolution of their Closed Won Opportunities. What are the required parameters to build a lens that displays output similar to the image shown?

Question90: Einstein Discovery is a tool that:

Question91: When Analytics runs a dataflow that accesses Salesforce objects, which user does it use?

Question92: How many groupings can you have in a Compare Table?

Question93: A consultant is asked to configured a user to view a dashboard, within a designated app, without the ability to create and save lenses.
After adding the user to the app, which action should the consultant take to implement this requirement?

Question94: In Einstein Discovery:

Question95: Philip adds a recently created Seed Bank Orders dataset to an Einstein Analytics app for which the Mosaic Seed Bank project team has the Viewer app role. How much data in the Seed Bank Orders dataset can a project team member see?

Question96: Exhibit:

Which two statements can be determined based on the Why it Happened graphic above' Choose 2 answers

Question97: Max of objects that can be enabled for Data Sync

Question98: What does XMD stand for?

Question99: Yasmine told Danielle she's interested in using the artificial intelligence provided by Einstein Discovery to enhance analysis Mosaic probably wouldn't have considered through their own means. How can Danielle use Einstein Analytics to load data into Einstein Discovery?

Question100: Refer to the graphic.

Einstein found a recommendation to improve the story: apparently there are two variables that behave the same. Given there is no additional information, what is the correct action?

Question101: What kind of insight is "What Is The Difference"?

Question102: A dataset is ready for analysis in Einstein Discovery.
What is the first step a consultant should take after the data is loaded?

Question103: What are predictive insights good for?

Question104: What do Analytics apps do?

Question105: How do you post to Chatter from a Sales Wave dashboard?

Question106: An Einstein Analytics consultant is asked to add a new SalesTax field to a Product Sales dataset. The formula to calculate SalesTax is (SubTotal'CountyTax).
Which node should the consultant use in a Dataflow to calculate and insert SalesTax to the dataset?

Question107: Before using bindings, you can try using facets to specify interactions between widgets.

Question108: A Senior Sales Business Analyst asks for a dashboard that contains fiscal year product opportunities. Information is maintained in a spreadsheet which is comprehensive, but its contents often need to be explained. After sketching the dashboard, the consultant is ready to start building.
Which concept should be applied to this dashboard?

Question109: Upper and lower limits on columns (vars) in discovery:

Question110: Einstein Discovery gives you several different kinds of recommended insights. Which of these insights is descriptive?

Question111: In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.
Which SAQL statement will fetch all Opportunities, even if they don't have associated Activities, and fetch related Activity data, if it exists?

Question112: A company wants to build a webpage that displays KPIs that can be derived from values in datasets stored in Einstein Analytics. How can an Einstein Analytics consultant derive those KPIs from those datasets?

Question113: How many stories can you create in Analytics Plus?

Question114: When you assign any Analytics permission set to users in your org, Salesforce auto-assigns the Analytics Platform permission set license to that user.

Question115: Max Analytics API calls per user per hour

Question116: You can get data into Einstein Discovery:

Question117: A client has a dashboard for Sales Managers. They want to have a list filter that shows the name of the month. However, based on the "CloseDate_Month" field, the list filter shows numbers instead of names.
How can an Einstein Consultant use the Dataflow nodes to generate the name of month as a new dimension in the dataset?